Tabela PatMaterialStatus

Definicja tabeli PatMaterialStatus

Name

PatMaterialStatus

Code

PatMaterialStatus

Comment

Slownik statusów (aktualny moment w procesie technologicznym, w archiwum itp)


Lista kolumn tabeli PatMaterialStatus

Name

Code

PatMaterialStatusID

PatMaterialStatusID

PatMaterialTypeID

PatMaterialTypeID

Active

Active


Kolumna PatMaterialStatusID tabeli PatMaterialStatus

Definicja kolumny PatMaterialStatusID tabeli PatMaterialStatus

Name

PatMaterialStatusID

Code

PatMaterialStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatMaterialTypeID tabeli PatMaterialStatus

Definicja kolumny PatMaterialTypeID tabeli PatMaterialStatus

Name

PatMaterialTypeID

Code

PatMaterialTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli PatMaterialStatus

Definicja kolumny Active tabeli PatMaterialStatus

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Lista kluczy tabeli PatMaterialStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PatMaterialStatus

Definicja klucza Identifier_1 tabeli PatMaterialStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment